Show All
Top property as it applies to the Application object.
The distance from the top edge of the screen to the top edge of the main Microsoft Excel window. If the application window is minimized, this property controls the position of the window icon (anywhere on the screen). Read/write Double.
expression.Top
expression Required. An expression that returns an Application object.
Top property as it applies to the Window object.
The distance from the top edge of the window to the top edge of the usable area (below the menus, any toolbars docked at the top, and the formula bar). You cannot set this property for a maximized window. Use the WindowState property to return or set the state of the window. Read/write Double.
expression.Top
expression Required. An expression that returns a Window object.
The distance from the top edge of the object to the top of row 1 (on a worksheet) or the top of the chart area (on a chart). Read/write Double.
expression.Top
expression Required. An expression that returns one of the above objects.
Top property as it applies to the Axis, LegendEntry, and LegendKey objects.
The distance from the top edge of the object to the top of row 1 (on a worksheet) or the top of the chart area (on a chart). Read-only Double.
expression.Top
expression Required. An expression that returns one of the above objects.
Top property as it applies to the Shape and ShapeRange objects.
The distance from the top edge of the topmost shape in the shape range to the top edge of the worksheet. Read/write Single.
expression.Top
expression Required. An expression that returns one of the above objects.
Top property as it applies to the Range object.
The distance from the top edge of row 1 to the top edge of the range. If the range is discontinuous, the first area is used. If the range is more than one row high, the top (lowest numbered) row in the range is used. Read-only Variant.
expression.Top
expression Required. An expression that returns a Range object.
This example arranges windows one and two horizontally; in other words, each window occupies half the available vertical space and all the available horizontal space in the application window's client area. For this example to work, there must be only two worksheet windows open.
Windows.Arrange xlArrangeTiled
ah = Windows(1).Height ' available height
aw = Windows(1).Width + Windows(2).Width ' available width
With Windows(1)
.Width = aw
.Height = ah / 2
.Left = 0
End With
With Windows(2)
.Width = aw
.Height = ah / 2
.Top = ah / 2
.Left = 0
End With